SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805941 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805941 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283597,288882,730375,200060,476388,442748,1015975,193568,148625,922897,573722,793092,354684,580988,488515,14479,811419,202796,876234,586740,531027,1022424,291741,1019302,275781,646462,467739,33254,83929,355745,900408,524528,415604,732448,686501,598532,628540,196435,349554,57029,310401,176047,712746,949016,664533,231559,351774,155864,49763,2332,966466,14995,1032753,848536,185739,590795,20953,242417,869957,78887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]