SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26543 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26543 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258770,374834,705571,998564,152205,558547,1025282,14384,260524,317793,987976,996276,194091,193866,904453,960882,1000352,495716,610342,966470,765760,81417,56557,737562,627404,153442,1209,317158,399600,24574,242586,421372,322008,481890,113281,557639,86815,989874,47848,399147,293209,692731,844333,594748,562703,118280,429355,993836,819168,249026,526067,615554,784573,1039103,10484,755220,685367,250487,208861,969701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]