SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550765 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550765 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104484,900440,929188,862991,1011929,913914,641452,1017179,460635,1047253,165048,922827,51496,2685,145421,902097,779835,408004,350210,108633,967521,46696,673297,741970,924123,780875,564415,289596,274914,350518,706332,876125,87661,432571,485469,979933,978083,404983,827968,591240,582489,523270,907365,1005917,588048,795460,1031052,632457,1015026,554170,40058,887310,673145,979625,136555,830122,790765,140096,591014,46189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]