SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341569 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341569 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288081,818368,677386,908616,783793,428684,252654,212191,180927,1028576,186377,780331,246175,993053,936401,843248,556192,975354,465951,115562,53751,286068,618401,442676,103572,370181,515081,839363,99684,776983,1039277,482867,170657,135593,60512,418887,924124,353423,961724,648237,543196,97713,641921,988457,117237,724697,741837,954201,428356,441594,517882,659156,814168,808390,18214,542049,125535,1039409,465105,582586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]