SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200863 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200863 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917425,773180,295572,203357,310113,512161,951552,28543,121158,650256,645953,135391,540534,674420,983711,912704,276186,919997,83366,381850,638080,904144,423868,794695,567486,19345,943947,65858,687952,887759,581588,59528,98925,539393,912635,704481,540614,721777,776039,227527,200430,554595,860009,373897,207322,70936,112696,521895,830458,420745,151492,753046,209285,875430,385035,834691,214844,540669,546542,700924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]