SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56609 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56609 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47054,860124,306651,72814,783185,761897,206697,570149,215141,759851,738657,711959,944576,292212,521104,351843,659335,2835,210371,169615,705149,452257,680550,912943,261449,160658,51410,282434,810732,212932,988776,25601,415839,32416,385091,705571,241147,263102,766764,116445,224586,483712,750704,744496,699721,593662,1045470,815478,475037,42494,669589,923570,918413,560792,120194,706471,243540,1044000,751138,807550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]