SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450961 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450961 [ RunTime:0.005462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662263,453866,879288,315674,181482,802111,474746,891856,1005375,731682,684578,718882,879098,818807,160140,519616,906347,1041913,439132,171827,686922,518460,636274,398797,275610,574759,521048,654126,983447,963969,177357,527193,562143,1003233,733345,105098,135346,367493,745813,695933,1022597,367172,348772,215349,582517,534387,1002220,637326,19670,900876,308127,419332,726438,622330,14681,742040,409007,1033555,1028057,60718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003277s ]