SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536616 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536616 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709647,633682,831828,497583,426375,901970,860079,20835,429033,1008042,765825,920985,529964,732902,912344,570919,986689,962252,336120,569836,216592,167269,727190,234772,669188,69174,418938,809899,952861,442132,848652,281491,174365,991235,359296,525212,202980,418226,796851,453236,98911,302182,674540,376099,484164,659163,1024062,810817,322017,641679,861551,112388,958116,947111,360877,12382,832809,463234,297531,937976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]