SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316601 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316601 [ RunTime:0.005010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651542,696109,587398,15382,191278,1012073,607897,278886,425299,706077,820336,15066,938,985043,371833,385055,282075,73580,918459,575387,355195,658499,852232,513610,959598,590666,720869,1046860,470052,378785,432185,341815,216030,709889,207028,805546,30987,1047482,275290,423198,377705,333523,242870,157060,318729,167967,520060,713267,819766,298273,430571,926588,274515,645090,531404,582170,294589,1035883,986565,109253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]