SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302017 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302017 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450596,676909,301962,56774,239152,256465,282274,811690,772682,258837,531476,244136,438672,291038,1037025,837269,106951,42564,631724,661181,727383,491680,797884,828449,190222,411916,344842,84874,619725,745439,271591,853927,964253,391761,329083,1009973,677562,276096,887424,721250,819770,531564,628693,522895,244725,185727,723697,441459,519103,1011303,113923,292543,1041136,451720,691253,900073,16793,98019,481708,375896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]