SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012525 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012525 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495893,596470,488569,301234,422743,171383,557085,518527,807750,759073,355568,626316,13106,854136,2099,1019502,247859,471787,881136,417696,925151,792062,558964,651738,174653,223458,722228,238142,852676,399347,494590,850445,910958,109615,250138,393272,390558,174205,681231,408518,312685,612852,420912,181188,185297,850165,334899,257571,338699,352462,900485,1006926,1010041,682845,980915,605401,257102,16117,143056,737331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001689s ]