SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472083 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472083 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305842,278773,177102,492012,948286,1007721,669258,584633,1023552,168486,203345,418914,258752,10580,682358,729253,948362,754238,601473,571428,511604,282369,864934,235295,887230,351362,861554,186199,797351,998113,885957,127138,602662,235940,934825,1039565,463319,424685,237608,930599,1006150,904655,604665,934400,931457,68854,1040777,468567,341149,320007,591072,168692,471391,471894,957953,401999,671130,457682,455971,819015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]