SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461424 LIMIT 1 [ RunTime:0.001384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461424 [ RunTime:0.003033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246006,935365,500274,359425,691634,36935,198245,100735,1044404,617975,864632,875164,472606,725011,1032453,478601,63164,372880,142732,365013,650604,216107,467332,705419,346505,10541,959462,519147,909159,982367,842936,730385,1001234,129178,322480,622398,204708,563820,943777,721346,505197,897978,321769,283395,33439,243903,685662,823756,1040838,892415,855866,97237,686766,889652,701855,859879,85681,298657,6453,277124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]