SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028545 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028545 [ RunTime:0.006013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919528,711870,940980,95945,175478,952156,311425,201085,28862,947564,357798,546800,93874,746959,429812,297049,1015809,444554,637937,12161,731657,452374,319855,337763,490462,341633,491651,511679,968567,453814,959325,426027,285816,8881,132027,629380,507602,296196,753248,677403,90348,913977,494294,505519,117629,847671,8863,372863,967192,818508,988105,642401,614540,267964,241229,1006405,226932,650958,163307,492231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]