SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178213 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178213 [ RunTime:0.002823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313003,28161,38027,945656,72837,530443,507885,928773,186808,669516,169021,137129,430335,794567,425474,486320,249828,361262,886506,1005775,694979,245966,589936,712907,911824,366926,922197,580885,694686,724319,805542,196879,125408,885885,73819,885773,973691,485979,115814,48867,862267,457443,754348,211458,679566,451270,265121,408259,1035288,711140,525128,139215,982273,516747,617228,289023,934753,913053,845701,806039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]