SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 366984 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 366984 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32971,380298,1001192,951063,1011773,253608,226797,794571,456778,387094,60702,404401,495681,424604,14626,527734,60457,507055,478568,253565,358746,414975,771180,977554,617164,75541,615265,128916,956283,463024,999649,544429,960731,258390,943087,245151,47618,467954,101944,584049,979168,447220,471575,537121,854376,517649,546287,212195,1032952,862496,878039,638962,737923,849711,590115,367355,1015333,292916,309108,585881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 366984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 366984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]