SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980909 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980909 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844072,97412,722539,698479,260082,737937,906354,456961,1030044,721453,1043446,988280,361202,776669,767681,202467,531594,351236,1030433,666046,46461,283502,642576,604374,729934,472539,95571,789228,585416,386816,370137,557160,444917,276649,482434,215218,781641,1001728,124261,147422,478678,22200,265141,918684,535119,865017,865277,766718,944569,405504,104817,149412,827881,307426,1000475,550213,986947,601324,44067,1015011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]