SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514879 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514879 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321322,37759,847497,672800,321416,140105,761992,272404,868186,535049,178206,229254,241326,209120,802984,256991,269952,325884,336979,751590,996336,211477,246200,1033847,474178,495651,908186,575750,994018,972615,141149,685681,852880,446440,819134,181445,67281,622879,409963,1041918,21761,384002,90614,53538,159667,909284,564085,721309,693680,526381,491030,988378,371203,589725,570746,471756,245875,250908,120482,278237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]