SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516506 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516506 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553511,141007,992123,858026,336056,270699,466071,40026,313372,379175,869233,892451,283172,592160,337711,451200,662337,311437,305516,672358,523218,431204,685513,76152,713652,739027,628656,137861,753663,656629,165004,534844,290785,1026619,1045148,1035425,757618,56923,164272,514652,500542,226523,683393,50219,794121,316823,12183,465595,183016,875207,701449,557430,209946,695417,64042,210411,224719,407032,715946,506439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]