SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506629 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506629 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194029,1012988,780102,925413,547956,812841,660894,116188,537805,548266,379825,797513,610954,414831,850105,352343,469892,752803,940263,357622,782165,501009,818100,916688,602417,627477,306862,420972,1045746,117594,501756,548900,616391,404587,400815,222925,1003156,629462,285440,555200,593647,679689,487116,503806,999163,978534,49452,989672,249113,355839,37409,497455,998836,518103,798796,1033639,381299,143716,829372,679794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]