SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414099 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414099 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298623,376752,831190,44073,353780,58979,481192,1039216,85364,745529,258115,1003127,840930,198175,675134,187017,121449,643856,353893,227098,194849,418349,394539,50933,506276,7177,129391,820963,576574,135424,750199,349780,834126,743422,203503,151514,614828,755136,472399,344395,498765,189718,542389,61454,137896,253806,1017176,831686,738856,318846,813112,617654,960544,676020,796437,265329,204089,543926,483585,443756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]