SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685219 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685219 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980009,93161,242369,192410,388802,423199,367484,352990,1027953,315161,27022,136401,97286,699405,194994,398944,816263,548476,174141,700741,60340,277989,952446,224772,600156,920106,319700,314900,805848,266434,349259,229727,440226,391552,409730,243474,164999,244330,954925,380056,181355,495212,166562,838701,160919,751825,525145,210453,599575,42346,1044996,707867,947697,374564,896183,573167,270836,646794,972547,588475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]