SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475013 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475013 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309688,294410,5715,367024,576397,279408,812196,40572,786118,267605,395786,15751,775703,747899,174094,619063,968007,159331,642279,993157,819767,914975,225146,93041,158390,8727,222480,697467,818624,735863,1004207,596279,811845,861621,773295,290516,159487,204560,826982,291950,953522,454293,642018,838946,347284,276293,350388,221753,230322,749828,1029081,712686,784938,490571,699874,1031330,943880,892547,466785,624579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]