SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580201 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580201 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993595,33102,987151,429695,84376,1020886,578168,404699,644487,443121,398682,808559,406089,199026,523184,367544,486844,610279,927838,987807,157851,495427,231665,574911,837733,432865,600075,538795,760325,166970,699489,271814,590290,762612,1026982,772491,908271,455459,894364,766844,710643,555295,738843,262597,948737,478577,746968,1006359,940262,190214,425577,528993,431047,45076,763197,255471,930318,1007828,410860,641940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001109s ]