SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971307 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971307 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546567,993663,726429,755854,651058,966237,281918,188303,295149,306110,440884,668446,347664,969332,856311,827873,967509,763865,343324,70180,804692,209507,698265,92723,211353,778512,686815,756519,56186,661764,204187,671308,901481,51403,952423,666467,80028,325887,241721,689491,1006000,986142,462826,188446,1006822,174780,468122,994864,624699,896997,829547,340711,559413,2503,570205,249159,247298,442138,672529,14488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]