SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402974 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402974 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364464,245895,452943,780956,27196,394199,141371,224572,620209,799884,301967,872652,244590,1046737,247716,982610,30713,10213,370829,630452,1019772,284572,137787,850128,951293,889115,1033509,914503,290393,639910,253283,875725,331528,173120,527882,535085,1041214,284507,598307,333363,250782,746746,583022,236673,166512,167980,579484,239662,941578,120002,1007771,436102,741928,68631,316287,588616,586279,322641,355899,545239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]