SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255411 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255411 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204708,260115,730872,457930,395764,1046722,559865,605804,762508,394775,665137,947070,110685,249030,851236,171759,385164,984213,424366,730868,601253,609571,221429,291902,610764,658907,704157,62379,1019154,256105,393202,536894,707783,442851,479278,376258,44535,663574,345933,71698,691196,445275,297705,518830,237968,541158,436835,122832,124653,828780,307762,504721,370549,5114,461767,849581,436430,505857,623179,813718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]