SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174991 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174991 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171009,54087,634613,825475,24958,371821,639124,915590,357571,244366,748038,177418,895232,824979,642985,227173,224148,899350,102714,184000,688603,525965,185680,357997,687356,843836,284436,241160,729389,200970,604418,130278,547516,409237,642743,255549,653349,989807,6168,71808,894984,49237,894601,532309,376262,216601,161510,372834,148365,759069,144164,922900,17908,323708,453551,684109,647515,498897,1048319,102211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]