SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406602 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406602 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888663,1013741,104088,831512,408352,268128,565568,793082,815117,430820,399501,965932,93629,51176,138394,515871,848485,141191,423375,328962,660108,851668,980894,1035713,712824,615654,474514,373644,134026,170359,547713,423351,157555,465108,15870,43837,300968,972523,435747,589905,1006669,764867,331485,469932,964834,374744,406832,136817,11861,928335,993456,77770,688449,790533,575605,390896,808122,855920,271640,391966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]