SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427011 LIMIT 1 [ RunTime:0.002012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427011 [ RunTime:0.002912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565173,969624,836037,216384,952219,468211,846839,1017914,540035,817449,701817,621399,953938,952252,368048,836386,334112,768458,186226,905607,120187,972002,972515,848453,834381,379161,796277,577232,962568,531212,84335,174273,897241,61733,481305,660207,152448,584560,276796,471114,674595,653950,924667,328096,232580,148977,864847,32454,462016,489612,971248,177060,649780,509231,133903,55949,307697,204665,943092,26627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]