SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534323 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534323 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884255,607661,240910,523692,61455,796729,351994,664935,530163,497582,714959,56735,864977,238735,1003643,379391,111337,210500,169658,810124,1048067,678118,137742,628496,566874,144878,853136,1046763,902245,163031,966612,376729,12896,80306,890379,334716,421154,607765,747953,469437,938027,924243,1020510,589533,533434,143940,992001,348959,164684,207134,693793,463403,913682,847094,1046824,439099,1014025,515791,702801,574231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]