SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642513 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642513 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005423,998862,405348,511967,371534,346137,660589,104777,89239,831099,631867,875020,828281,975709,561020,895851,1036647,352250,956628,210097,561403,517115,340595,1021623,319199,348662,879746,717280,132814,403387,714988,449986,56764,268194,324202,411095,1032709,560429,984997,586662,736420,192133,753163,497836,327937,331276,1010326,896501,43569,361702,415003,994470,422022,316001,1000362,518134,943200,847812,967677,195995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]