SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495928 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495928 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276139,721488,263904,640709,970366,117471,758039,258111,166170,474907,36000,544082,332961,93823,399801,325822,959285,940557,592539,885523,875189,465760,55563,815059,710839,214489,627479,839719,7989,469610,561029,436519,885161,684090,314050,73066,950490,398499,796392,608899,742738,945307,139864,982098,155761,672156,563854,417259,482621,959906,690211,392878,145679,56515,147831,972750,631348,27266,144997,156392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]