SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43830 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43830 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256409,532134,266103,745864,84634,543556,605034,275731,449733,216519,95008,856933,671221,814539,826627,440342,1014325,346395,460061,663305,174264,442179,682248,265207,516679,244432,393014,745057,619180,528317,719958,211807,484521,947130,743911,696706,757435,28268,1036035,141070,421807,475403,216045,843419,113224,333069,513529,1024889,623276,4586,483141,992707,617731,778443,752864,987294,38732,634102,466122,813932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]