SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103071 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103071 [ RunTime:0.003024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843550,147827,1038096,781498,6490,751101,547878,308501,193424,613611,15233,698314,511083,868936,1007513,230109,456237,460446,1021650,70850,729294,418945,821992,1047338,216888,667381,884931,817500,364891,342811,1028379,37733,15514,38899,817723,861198,562858,851451,201560,152389,469628,318005,221149,91301,637718,920276,879984,216482,481906,940032,600362,274791,1005083,137959,934346,1337,438737,552823,257833,315392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]