SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201220 LIMIT 1 [ RunTime:0.001248s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201220 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681949,726687,604116,571731,90612,603429,148132,145991,68428,46825,98183,924469,96873,437656,1012061,757355,709085,186349,942594,751299,1014822,699414,254318,266161,358078,640465,809673,250552,404949,721196,551109,88150,727668,950473,41289,746708,276822,290120,531162,142809,328850,500667,431101,571159,804325,402306,146977,911720,492646,270209,573395,188457,138758,365265,582027,44100,375993,645899,375238,558126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]