SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599512 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599512 [ RunTime:0.003661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613879,772574,892806,334514,11092,188419,51319,983907,980213,126718,14206,344268,751464,393872,564480,306878,144163,1021393,344684,105015,251993,1013773,356422,930831,135793,409305,250917,882192,537880,42194,48291,108887,301375,578012,783817,299133,52870,348250,341940,87409,503088,125265,781063,853911,916900,987376,444613,829695,826738,260603,133206,701438,399352,498917,180185,346958,506785,846812,767263,404355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]