SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299710 LIMIT 1 [ RunTime:0.001521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299710 [ RunTime:0.005929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543062,425656,172168,94249,598396,705309,749141,100046,708586,675286,116399,963741,8352,549928,654466,857539,385782,604071,371983,235839,40915,860698,61529,122656,944621,549792,268953,872710,685789,812629,224160,370678,726253,808110,813803,404745,357939,980369,594076,913895,606832,1039736,197558,28526,647352,765633,581895,333190,592387,693994,342634,88277,201167,53799,448280,185888,405155,416830,1018461,571265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]