SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015854 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015854 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910517,386485,251883,846918,682165,497269,42293,301456,170499,444919,194512,999738,712782,220522,428458,857537,59002,384012,312036,1030085,324478,276350,1035272,165941,558458,737197,156764,763961,120998,658049,702780,937174,296501,304921,245685,602646,242266,999624,390426,426529,362419,410288,104804,797059,977390,77592,586367,614333,236250,429053,790478,537730,762976,945171,106264,360834,48564,1044099,745095,114699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]