SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 78101 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 78101 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703495,326873,912951,78894,160278,974845,971867,717938,425440,680268,31035,942389,251825,950864,156688,338629,357535,331726,179797,238184,866105,265210,665365,124894,921796,3098,86723,1037135,840582,741594,18817,454517,237556,909333,542651,12617,559339,624166,227046,524412,407394,14054,944467,661172,300526,917050,935550,864813,554300,223409,712519,45429,326216,931797,278677,694830,288956,644115,757207,800268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 78101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 78101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]