SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010031 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010031 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901453,126561,572953,507618,730264,586123,737249,42470,91634,808804,339106,319934,765983,432040,224150,405615,16449,479686,1005711,361868,267664,374705,17554,933057,372833,943929,839039,473809,839459,537685,34506,76078,758619,111034,819398,982497,1022715,276628,998211,60231,694107,720874,774748,828164,631682,12000,608324,511417,288932,435977,387875,285384,258195,597460,916258,416867,359971,652915,671046,855697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]