SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535220 LIMIT 1 [ RunTime:0.002128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535220 [ RunTime:0.003486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670714,936404,967461,596189,771949,404293,454897,804052,470644,50803,391043,86105,315184,725867,1004694,398760,790656,157675,661674,290326,381764,578239,337593,460697,9986,397568,115336,35329,298987,152582,799442,80824,700457,749808,976843,122213,1024661,866551,78416,878519,411713,639669,885613,468389,562879,645300,688491,425140,752445,716412,4551,1034975,895028,655279,33436,914447,485567,23572,629677,328207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]