SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527601 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527601 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287308,834963,198304,1034227,1039494,760915,364256,483745,431992,227846,53118,761016,100779,947467,762155,935281,248825,241760,215324,214678,852478,621370,99673,928885,141354,455186,937794,382960,125818,531004,539423,438837,143914,941334,412864,1025363,848094,659995,299384,60083,630541,839681,290383,609715,150897,85287,568470,1012700,985380,980313,763290,984175,729017,767312,619433,219361,156912,531332,692828,392262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]