SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310220 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310220 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446711,740584,416770,619460,468122,251715,218380,900078,351206,523068,676295,88542,761506,74545,742787,338581,995678,636173,948195,979761,693968,282418,763376,815530,1004198,1040086,383332,126284,166317,572138,842605,1024018,647567,484966,117190,113687,1025202,395672,26488,613315,478071,18701,470286,388939,474557,1011366,37429,983663,176746,631166,468173,622078,880336,408382,865927,902845,896413,379252,620113,570268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]