SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309106 LIMIT 1 [ RunTime:0.000871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309106 [ RunTime:0.003115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571893,193793,1005171,708686,633048,404533,524860,990312,227683,71922,164280,215372,624404,239879,226682,607998,745038,979390,1026721,348709,101460,342118,299803,1018216,215995,59451,367012,388349,447168,381043,466099,241035,584400,476423,160889,444726,839049,718637,379159,315097,1005252,502696,187233,409011,134353,433839,680579,119687,1020532,820256,856346,796066,662530,149845,520125,947476,692163,274847,675175,881700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001597s ]