SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505590 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505590 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608046,677573,123075,268463,1039443,702423,239175,792624,1011320,22808,37065,851450,391876,298144,760580,573026,80943,655815,145146,114337,445470,420547,347462,62071,427284,183475,158614,419355,1045528,268916,611209,607548,250202,100625,768747,274516,649860,717409,187477,292240,90290,289440,956392,323737,423954,618138,140431,57163,824852,839044,931346,814096,511027,98059,351226,39913,574723,268784,251559,639397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]