SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503014 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503014 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788058,501989,173365,716329,391740,48809,434551,731381,397656,956141,740507,531208,302150,239489,232258,970229,343509,393568,704570,303402,868251,410168,287179,621394,97576,419434,892185,719087,759122,669010,22040,567726,335852,935521,771169,404655,228866,258547,346872,105373,762232,44787,644342,339410,915057,411944,945531,232762,732979,17990,683373,368747,906298,207326,164285,1047701,747410,815268,19426,364197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]