SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283011 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283011 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222160,264487,941322,413388,1043937,912193,433037,369017,533137,665152,930125,870132,66858,270888,791582,52326,865060,673169,231239,770552,321628,18410,808686,825899,982024,344163,1023028,592465,179938,227353,555248,269413,545970,526018,996157,115856,801172,887547,593249,280204,477980,532989,49665,720659,387521,32266,116996,909938,304523,993802,529666,470887,650377,218462,931329,459943,133813,66459,976558,50624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]