SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543814 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543814 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677500,394002,1009693,619187,491520,24677,463515,861425,839015,709510,547871,880638,551994,634418,984927,428791,885917,180862,602622,574437,447844,812729,19052,1033125,1037824,382031,1027319,688451,219172,991726,101780,251891,93629,482326,216105,334018,105640,163849,484485,770213,502064,187579,728863,887876,766811,467072,793787,464086,87950,961505,926416,65529,470011,327955,955598,41225,885684,762632,32704,844123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]