SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516802 LIMIT 1 [ RunTime:0.001714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516802 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185163,366489,1035513,414864,69367,538053,794627,430241,367849,679049,1030854,204107,961120,1009800,1009299,310324,652055,107199,137796,249007,530812,765258,149861,749888,739828,434478,368409,468198,949796,356291,510539,426665,897778,951896,665051,142903,829105,632559,333679,700634,35546,856451,651263,624628,444605,914248,153110,337059,829609,945764,295900,232261,722878,209961,627752,137847,240290,392216,731178,497841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]