SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542512 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542512 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623235,470691,759121,748600,270101,509114,647234,613520,8250,236252,956151,785785,412879,380012,608857,140669,1030342,382971,748979,979225,469853,987995,721317,773600,196150,714167,590954,290141,387468,156449,190294,183694,947658,148738,398504,820747,854058,878386,130197,3875,296772,749436,760642,334896,305769,143818,1042588,459447,822898,209798,265941,757653,50706,747554,191137,871028,391595,30424,129911,18561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]