SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498241 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498241 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281489,430793,840326,164928,384914,259033,503362,774502,797924,269787,853872,929813,307172,828804,764347,435849,934596,605512,880740,580600,56800,80470,687730,147867,820330,714248,392275,689099,328097,301949,973433,687471,945238,778759,275548,522675,10077,896301,531977,717559,730752,313393,200948,911610,830882,991749,997193,865715,745844,114982,324969,26531,485832,501946,460802,436017,866090,212477,411778,934359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]