SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449016 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449016 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245816,1039892,909645,941691,232857,183275,936910,122734,473879,977626,209597,529579,43328,46515,421476,290514,728309,7275,852713,963996,598184,440270,190072,683701,789000,886023,954673,489470,200658,821827,902774,912327,413273,361338,1004824,454542,399213,385317,86040,480866,1021116,993024,674368,800445,856843,165694,194387,853184,565100,566739,28762,415310,814150,648791,630075,786425,389156,848592,152417,27871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]