SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039898 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039898 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212074,686736,585114,893780,721084,211457,399217,164846,278223,476233,677243,374199,695983,679025,25217,67303,504582,693464,147670,586568,496863,572518,918372,624786,393159,645200,744314,108066,443569,737041,924397,145522,880515,107668,662705,718917,994296,144411,461215,814340,862325,366025,619138,562001,385784,957889,660550,552713,379937,143575,790103,866154,310332,745407,75406,1027988,205647,31626,395974,813487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]