SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813381 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813381 [ RunTime:0.002732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933627,62193,253495,1042263,572836,857088,377180,217433,45070,480503,917555,1014690,784355,242908,402696,887711,257454,468669,862109,39194,358156,123548,18653,367129,131760,1012796,279930,405207,242556,404032,830763,684877,578038,882743,541276,768612,391888,443780,1042298,767103,141752,269705,876654,111165,436925,346684,326093,859828,332044,623345,964149,565652,843210,136962,809050,408552,765422,79079,774154,836254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]