SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004063 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004063 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842007,802102,738129,418012,446683,757636,217513,460522,552837,29699,790819,364777,452872,32935,608923,457186,1019563,332286,834334,988484,266152,618234,440966,191503,163494,739005,868946,281450,629625,61800,954047,48783,413425,814011,52685,149583,303594,177316,548664,326503,772570,222659,237205,342102,343946,763817,751769,609059,171834,841451,332511,164611,541300,31185,794685,1014839,412871,953954,198232,155982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]