SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041181 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041181 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831365,896257,247644,1013495,203953,401011,531934,817628,1020978,965897,175549,791338,323994,1021450,313614,722129,148080,914464,959303,465979,1038563,257822,650087,349558,880372,674700,507806,29387,483287,5529,351804,354239,835502,899610,787627,773683,355954,660660,717823,67266,650583,943357,464936,501536,596175,639353,710237,969660,809576,812624,1038183,187360,907389,867882,240418,5029,346554,12702,395356,104739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003273s ]