SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501713 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501713 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763457,856743,129203,479122,145363,680960,238397,782477,383064,926180,202505,599549,77245,884032,89906,563184,909959,258903,497925,1039388,820706,578173,721411,618496,985561,718405,34660,638524,523705,655795,713549,890733,794767,432593,99778,933554,175463,667065,428951,98920,298003,101183,339344,268813,1011363,1013628,914174,960335,825263,141231,346226,673218,629533,352440,709826,745456,430211,997459,924686,40119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]