SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434046 LIMIT 1 [ RunTime:0.006295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434046 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990965,994535,724164,195690,869629,397920,721056,661503,894390,450527,628680,28050,891538,351328,882577,199901,717474,43002,358996,251864,693704,210092,335901,720882,315876,25088,108059,837443,750872,200646,1009794,536063,972452,361736,176231,216614,575142,375568,568846,307084,696627,610108,945889,184236,108777,881428,313095,1044017,383143,712714,142058,668413,912184,874319,733353,112747,122538,982739,734840,274674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]