SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315021 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315021 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93752,329103,585362,724143,621512,49543,924389,411149,625827,845906,1044159,1041483,894918,979400,624992,382576,931240,9676,607929,164693,643813,544642,1023085,804781,705735,1004484,134766,209081,945743,1018205,940973,575935,156810,330937,403686,1017369,851957,387696,49774,792952,171778,641070,1045367,825897,52069,343116,728198,125452,506389,808672,276981,248212,1032786,199010,116159,620003,696958,199178,541729,451315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]