SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502457 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502457 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744637,254027,596941,799093,682003,812448,346377,858075,709529,743247,735110,272841,1000877,373483,774170,518435,878571,889015,494567,236339,694522,823386,704974,972765,471496,743888,211098,1003833,231937,984331,235113,985563,403939,946442,835403,894365,493866,646490,345251,254358,659171,982784,943044,801036,163153,1039279,320106,263057,699051,446639,263995,659348,965261,355552,965383,155378,783751,883060,38917,809489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]