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` = 503792 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503792 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89076,416840,264539,877923,566451,100372,160173,114542,614904,570377,775715,674909,838528,67471,255623,845567,630247,666392,261509,435163,185040,291736,694040,436545,869486,672632,560890,903030,615140,555461,200131,853453,421734,86364,773626,703693,202864,494396,465174,837669,432819,542253,957577,807335,1047007,17726,331203,281112,113818,890544,465166,187701,105525,124911,820824,727191,226197,608903,670822,460527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503792 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503792 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002017s ]