SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439160 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439160 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423772,62998,879033,488221,909990,661822,308714,216523,2335,70708,983314,1019587,499418,19227,967366,716296,229181,295525,821774,991613,921743,440965,200706,968427,588950,594697,632488,509600,755916,769555,696247,766122,90285,533225,58921,139278,408815,545989,25795,77622,572400,243083,842803,202013,149597,715606,30920,248141,541496,123040,521215,11784,980398,475912,903703,750175,362091,639517,385658,453469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001881s ]