SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534898 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534898 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402908,850200,1025486,174724,633744,411213,578255,209797,96774,342643,641872,339918,187809,646769,567804,1007172,734976,713681,460400,293524,218930,1025843,559820,468823,658261,310825,353989,219462,115002,63964,6891,990232,188317,422084,242561,522889,353943,567909,941811,117040,928957,187965,884132,916992,692861,411618,76301,1003645,464029,980504,918569,339761,704034,186095,135183,819491,156256,351636,430459,341049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]