SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584101 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584101 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387052,932669,6048,811109,30962,815253,364998,828894,296986,815278,399325,805430,837597,554671,168566,302347,178282,838077,774901,77076,7172,537881,140621,534160,42405,603976,1028097,180748,245773,742148,344452,814793,47348,323986,758359,700170,500568,176764,1024639,107102,489002,695014,685538,843732,553495,213193,744762,383777,511757,397872,158759,933148,38445,493731,181560,693398,480680,947433,389673,502877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001259s ]