SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403526 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403526 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843962,720649,78781,15673,681918,222199,896412,947054,103901,381510,244020,670659,423892,718647,453512,368531,798615,798831,182554,778745,431395,48063,256337,351036,604724,48836,14455,821740,73854,181865,647706,463963,195294,1042290,276801,598851,547343,729765,246980,165015,502615,349940,612310,720483,346707,910378,783070,44398,265423,821102,606685,836638,684678,367543,380545,831878,123558,571669,278454,285586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]