SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543812 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543812 [ RunTime:0.003026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199441,644409,105367,620609,1024321,724014,772774,1021471,19122,412766,790196,789734,1021508,809584,895156,1046144,790224,287126,550655,383101,437602,183542,29778,308644,392277,919746,618149,1011413,184886,421635,865966,626013,713944,104621,399002,865692,733250,537008,773888,109088,194185,390176,633328,596173,852517,75030,152248,936535,332739,1005459,866826,257978,745716,513906,71929,59005,126230,248411,203366,744641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]