SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356809 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356809 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386768,512312,415922,766741,1045661,955814,573489,232405,291858,5485,747309,992988,1017412,634943,350940,267024,226675,201899,713236,42130,95771,1044460,728038,509104,763883,253027,800266,955463,68079,928179,776863,830884,244572,7470,481262,289698,431516,960925,759327,357819,235644,712686,254934,998876,91133,832674,199910,868168,523811,567623,42784,255041,53422,317778,728264,854640,88913,410031,124348,233864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]